<?xml version="1.0" encoding="ascii"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
          "DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
  <title>killerbee.dblog</title>
  <link rel="stylesheet" href="epydoc.css" type="text/css" />
  <script type="text/javascript" src="epydoc.js"></script>
</head>

<body bgcolor="white" text="black" link="blue" vlink="#204080"
      alink="#204080">
<!-- ==================== NAVIGATION BAR ==================== -->
<table class="navbar" border="0" width="100%" cellpadding="0"
       bgcolor="#a0c0ff" cellspacing="0">
  <tr valign="middle">
  <!-- Home link -->
      <th>&nbsp;&nbsp;&nbsp;<a
        href="killerbee-module.html">Home</a>&nbsp;&nbsp;&nbsp;</th>

  <!-- Tree link -->
      <th>&nbsp;&nbsp;&nbsp;<a
        href="module-tree.html">Trees</a>&nbsp;&nbsp;&nbsp;</th>

  <!-- Index link -->
      <th>&nbsp;&nbsp;&nbsp;<a
        href="identifier-index.html">Indices</a>&nbsp;&nbsp;&nbsp;</th>

  <!-- Help link -->
      <th>&nbsp;&nbsp;&nbsp;<a
        href="help.html">Help</a>&nbsp;&nbsp;&nbsp;</th>

  <!-- Project homepage -->
      <th class="navbar" align="right" width="100%">
        <table border="0" cellpadding="0" cellspacing="0">
          <tr><th class="navbar" align="center"
            ><a class="navbar" target="_top" href="http://code.google.com/p/killerbee/">KillerBee</a></th>
          </tr></table></th>
  </tr>
</table>
<table width="100%" cellpadding="0" cellspacing="0">
  <tr valign="top">
    <td width="100%">
      <span class="breadcrumbs">
        <a href="killerbee-module.html">Package&nbsp;killerbee</a> ::
        Module&nbsp;dblog
      </span>
    </td>
    <td>
      <table cellpadding="0" cellspacing="0">
        <!-- hide/show private -->
        <tr><td align="right"><span class="options">[<a href="javascript:void(0);" class="privatelink"
    onclick="toggle_private();">hide&nbsp;private</a>]</span></td></tr>
        <tr><td align="right"><span class="options"
            >[<a href="frames.html" target="_top">frames</a
            >]&nbsp;|&nbsp;<a href="killerbee.dblog-pysrc.html"
            target="_top">no&nbsp;frames</a>]</span></td></tr>
      </table>
    </td>
  </tr>
</table>
<h1 class="epydoc">Source Code for <a href="killerbee.dblog-module.html">Module killerbee.dblog</a></h1>
<pre class="py-src">
<a name="L1"></a><tt class="py-lineno">  1</tt>  <tt class="py-line"><tt class="py-keyword">from</tt> <tt id="link-0" class="py-name" targets="Module killerbee.config=killerbee.config-module.html"><a title="killerbee.config" class="py-name" href="#" onclick="return doclink('link-0', 'config', 'link-0');">config</a></tt> <tt class="py-keyword">import</tt> <tt class="py-op">*</tt> </tt>
<a name="L2"></a><tt class="py-lineno">  2</tt>  <tt class="py-line"><tt class="py-keyword">import</tt> <tt class="py-name">MySQLdb</tt> </tt>
<a name="L3"></a><tt class="py-lineno">  3</tt>  <tt class="py-line"> </tt>
<a name="DBReader"></a><div id="DBReader-def"><a name="L4"></a><tt class="py-lineno">  4</tt> <a class="py-toggle" href="#" id="DBReader-toggle" onclick="return toggle('DBReader');">-</a><tt class="py-line"><tt class="py-keyword">class</tt> <a class="py-def-name" href="killerbee.dblog.DBReader-class.html">DBReader</a><tt class="py-op">:</tt> </tt>
</div><div id="DBReader-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="DBReader-expanded"><a name="DBReader.__init__"></a><div id="DBReader.__init__-def"><a name="L5"></a><tt class="py-lineno">  5</tt> <a class="py-toggle" href="#" id="DBReader.__init__-toggle" onclick="return toggle('DBReader.__init__');">-</a><tt class="py-line">    <tt class="py-keyword">def</tt> <a class="py-def-name" href="killerbee.dblog.DBReader-class.html#__init__">__init__</a><tt class="py-op">(</tt><tt class="py-param">self</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="DBReader.__init__-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="DBReader.__init__-expanded"><a name="L6"></a><tt class="py-lineno">  6</tt>  <tt class="py-line">        <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">conn</tt> <tt class="py-op">=</tt> <tt class="py-name">None</tt> </tt>
<a name="L7"></a><tt class="py-lineno">  7</tt>  <tt class="py-line">        <tt class="py-name">self</tt><tt class="py-op">.</tt><tt id="link-1" class="py-name" targets="Variable killerbee.GoodFET.SymbolTable.db=killerbee.GoodFET.SymbolTable-class.html#db"><a title="killerbee.GoodFET.SymbolTable.db" class="py-name" href="#" onclick="return doclink('link-1', 'db', 'link-1');">db</a></tt> <tt class="py-op">=</tt> <tt class="py-name">None</tt> </tt>
<a name="L8"></a><tt class="py-lineno">  8</tt>  <tt class="py-line">        <tt class="py-comment"># Initalize the connection</tt> </tt>
<a name="L9"></a><tt class="py-lineno">  9</tt>  <tt class="py-line">        <tt class="py-name">self</tt><tt class="py-op">.</tt><tt id="link-2" class="py-name"><a title="killerbee.GoodFET.SymbolTable.db" class="py-name" href="#" onclick="return doclink('link-2', 'db', 'link-1');">db</a></tt> <tt class="py-op">=</tt> <tt class="py-name">MySQLdb</tt><tt class="py-op">.</tt><tt class="py-name">connect</tt><tt class="py-op">(</tt><tt class="py-name">user</tt><tt class="py-op">=</tt><tt id="link-3" class="py-name" targets="Variable killerbee.config.DB_USER=killerbee.config-module.html#DB_USER"><a title="killerbee.config.DB_USER" class="py-name" href="#" onclick="return doclink('link-3', 'DB_USER', 'link-3');">DB_USER</a></tt><tt class="py-op">,</tt> <tt class="py-name">passwd</tt><tt class="py-op">=</tt><tt id="link-4" class="py-name" targets="Variable killerbee.config.DB_PASS=killerbee.config-module.html#DB_PASS"><a title="killerbee.config.DB_PASS" class="py-name" href="#" onclick="return doclink('link-4', 'DB_PASS', 'link-4');">DB_PASS</a></tt><tt class="py-op">,</tt> <tt id="link-5" class="py-name"><a title="killerbee.GoodFET.SymbolTable.db" class="py-name" href="#" onclick="return doclink('link-5', 'db', 'link-1');">db</a></tt><tt class="py-op">=</tt><tt id="link-6" class="py-name" targets="Variable killerbee.config.DB_NAME=killerbee.config-module.html#DB_NAME"><a title="killerbee.config.DB_NAME" class="py-name" href="#" onclick="return doclink('link-6', 'DB_NAME', 'link-6');">DB_NAME</a></tt><tt class="py-op">,</tt> <tt class="py-name">host</tt><tt class="py-op">=</tt><tt id="link-7" class="py-name" targets="Variable killerbee.config.DB_HOST=killerbee.config-module.html#DB_HOST"><a title="killerbee.config.DB_HOST" class="py-name" href="#" onclick="return doclink('link-7', 'DB_HOST', 'link-7');">DB_HOST</a></tt><tt class="py-op">,</tt> <tt class="py-name">port</tt><tt class="py-op">=</tt><tt id="link-8" class="py-name" targets="Variable killerbee.config.DB_PORT=killerbee.config-module.html#DB_PORT"><a title="killerbee.config.DB_PORT" class="py-name" href="#" onclick="return doclink('link-8', 'DB_PORT', 'link-8');">DB_PORT</a></tt><tt class="py-op">)</tt> </tt>
<a name="L10"></a><tt class="py-lineno"> 10</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt id="link-9" class="py-name"><a title="killerbee.GoodFET.SymbolTable.db" class="py-name" href="#" onclick="return doclink('link-9', 'db', 'link-1');">db</a></tt> <tt class="py-op">==</tt> <tt class="py-name">None</tt><tt class="py-op">:</tt> </tt>
<a name="L11"></a><tt class="py-lineno"> 11</tt>  <tt class="py-line">            <tt class="py-keyword">raise</tt> <tt class="py-name">Exception</tt><tt class="py-op">(</tt><tt class="py-string">"DBLogger: Unable to connect to database."</tt><tt class="py-op">)</tt> </tt>
<a name="L12"></a><tt class="py-lineno"> 12</tt>  <tt class="py-line">        <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">conn</tt> <tt class="py-op">=</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt id="link-10" class="py-name"><a title="killerbee.GoodFET.SymbolTable.db" class="py-name" href="#" onclick="return doclink('link-10', 'db', 'link-1');">db</a></tt><tt class="py-op">.</tt><tt class="py-name">cursor</tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
</div><a name="L13"></a><tt class="py-lineno"> 13</tt>  <tt class="py-line"> </tt>
<a name="DBReader.close"></a><div id="DBReader.close-def"><a name="L14"></a><tt class="py-lineno"> 14</tt> <a class="py-toggle" href="#" id="DBReader.close-toggle" onclick="return toggle('DBReader.close');">-</a><tt class="py-line">    <tt class="py-keyword">def</tt> <a class="py-def-name" href="killerbee.dblog.DBReader-class.html#close">close</a><tt class="py-op">(</tt><tt class="py-param">self</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="DBReader.close-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="DBReader.close-expanded"><a name="L15"></a><tt class="py-lineno"> 15</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">conn</tt> <tt class="py-op">!=</tt> <tt class="py-name">None</tt><tt class="py-op">:</tt> </tt>
<a name="L16"></a><tt class="py-lineno"> 16</tt>  <tt class="py-line">            <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">conn</tt><tt class="py-op">.</tt><tt id="link-11" class="py-name" targets="Method killerbee.KillerBee.close()=killerbee.KillerBee-class.html#close,Method killerbee.daintree.DainTreeDumper.close()=killerbee.daintree.DainTreeDumper-class.html#close,Method killerbee.daintree.DainTreeReader.close()=killerbee.daintree.DainTreeReader-class.html#close,Method killerbee.dblog.DBLogger.close()=killerbee.dblog.DBLogger-class.html#close,Method killerbee.dblog.DBReader.close()=killerbee.dblog.DBReader-class.html#close,Method killerbee.dev_apimote.APIMOTE.close()=killerbee.dev_apimote.APIMOTE-class.html#close,Method killerbee.dev_freakduino.FREAKDUINO.close()=killerbee.dev_freakduino.FREAKDUINO-class.html#close,Method killerbee.dev_rzusbstick.RZUSBSTICK.close()=killerbee.dev_rzusbstick.RZUSBSTICK-class.html#close,Method killerbee.dev_telosb.TELOSB.close()=killerbee.dev_telosb.TELOSB-class.html#close,Method killerbee.dev_zigduino.ZIGDUINO.close()=killerbee.dev_zigduino.ZIGDUINO-class.html#close,Method killerbee.pcapdump.PcapDumper.close()=killerbee.pcapdump.PcapDumper-class.html#close,Method killerbee.pcapdump.PcapReader.close()=killerbee.pcapdump.PcapReader-class.html#close"><a title="killerbee.KillerBee.close
killerbee.daintree.DainTreeDumper.close
killerbee.daintree.DainTreeReader.close
killerbee.dblog.DBLogger.close
killerbee.dblog.DBReader.close
killerbee.dev_apimote.APIMOTE.close
killerbee.dev_freakduino.FREAKDUINO.close
killerbee.dev_rzusbstick.RZUSBSTICK.close
killerbee.dev_telosb.TELOSB.close
killerbee.dev_zigduino.ZIGDUINO.close
killerbee.pcapdump.PcapDumper.close
killerbee.pcapdump.PcapReader.close" class="py-name" href="#" onclick="return doclink('link-11', 'close', 'link-11');">close</a></tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L17"></a><tt class="py-lineno"> 17</tt>  <tt class="py-line">            <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">conn</tt> <tt class="py-op">=</tt> <tt class="py-name">None</tt> </tt>
</div><a name="L18"></a><tt class="py-lineno"> 18</tt>  <tt class="py-line"> </tt>
<a name="DBReader.query_one"></a><div id="DBReader.query_one-def"><a name="L19"></a><tt class="py-lineno"> 19</tt> <a class="py-toggle" href="#" id="DBReader.query_one-toggle" onclick="return toggle('DBReader.query_one');">-</a><tt class="py-line">    <tt class="py-keyword">def</tt> <a class="py-def-name" href="killerbee.dblog.DBReader-class.html#query_one">query_one</a><tt class="py-op">(</tt><tt class="py-param">self</tt><tt class="py-op">,</tt> <tt class="py-param">table</tt><tt class="py-op">,</tt> <tt class="py-param">columns</tt><tt class="py-op">,</tt> <tt class="py-param">where</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="DBReader.query_one-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="DBReader.query_one-expanded"><a name="L20"></a><tt class="py-lineno"> 20</tt>  <tt class="py-line">        <tt class="py-name">sql</tt> <tt class="py-op">=</tt> <tt class="py-string">"SELECT %s FROM %s WHERE %s LIMIT 1"</tt> <tt class="py-op">%</tt> <tt class="py-op">(</tt><tt class="py-name">columns</tt><tt class="py-op">,</tt> <tt class="py-name">table</tt><tt class="py-op">,</tt> <tt class="py-name">where</tt><tt class="py-op">)</tt> </tt>
<a name="L21"></a><tt class="py-lineno"> 21</tt>  <tt class="py-line">        <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">conn</tt><tt class="py-op">.</tt><tt id="link-12" class="py-name" targets="Method killerbee.GoodFET.GoodFET.execute()=killerbee.GoodFET.GoodFET-class.html#execute"><a title="killerbee.GoodFET.GoodFET.execute" class="py-name" href="#" onclick="return doclink('link-12', 'execute', 'link-12');">execute</a></tt><tt class="py-op">(</tt><tt class="py-name">sql</tt><tt class="py-op">)</tt> </tt>
<a name="L22"></a><tt class="py-lineno"> 22</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">conn</tt><tt class="py-op">.</tt><tt class="py-name">rowcount</tt> <tt class="py-op">==</tt> <tt class="py-number">1</tt><tt class="py-op">:</tt> <tt class="py-keyword">return</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">conn</tt><tt class="py-op">.</tt><tt class="py-name">fetchone</tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L23"></a><tt class="py-lineno"> 23</tt>  <tt class="py-line">        <tt class="py-keyword">else</tt><tt class="py-op">:</tt> <tt class="py-keyword">return</tt> <tt class="py-name">None</tt> </tt>
</div><a name="L24"></a><tt class="py-lineno"> 24</tt>  <tt class="py-line"> </tt>
<a name="DBReader.query"></a><div id="DBReader.query-def"><a name="L25"></a><tt class="py-lineno"> 25</tt> <a class="py-toggle" href="#" id="DBReader.query-toggle" onclick="return toggle('DBReader.query');">-</a><tt class="py-line">    <tt class="py-keyword">def</tt> <a class="py-def-name" href="killerbee.dblog.DBReader-class.html#query">query</a><tt class="py-op">(</tt><tt class="py-param">self</tt><tt class="py-op">,</tt> <tt class="py-param">sql</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="DBReader.query-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="DBReader.query-expanded"><a name="L26"></a><tt class="py-lineno"> 26</tt>  <tt class="py-line">        <tt class="py-comment">#print "Query was", sql</tt> </tt>
<a name="L27"></a><tt class="py-lineno"> 27</tt>  <tt class="py-line">        <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">conn</tt><tt class="py-op">.</tt><tt id="link-13" class="py-name"><a title="killerbee.GoodFET.GoodFET.execute" class="py-name" href="#" onclick="return doclink('link-13', 'execute', 'link-12');">execute</a></tt><tt class="py-op">(</tt><tt class="py-name">sql</tt><tt class="py-op">)</tt> </tt>
<a name="L28"></a><tt class="py-lineno"> 28</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">conn</tt><tt class="py-op">.</tt><tt class="py-name">rowcount</tt> <tt class="py-op">&gt;=</tt> <tt class="py-number">1</tt><tt class="py-op">:</tt> </tt>
<a name="L29"></a><tt class="py-lineno"> 29</tt>  <tt class="py-line">            <tt class="py-name">row</tt> <tt class="py-op">=</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">conn</tt><tt class="py-op">.</tt><tt class="py-name">fetchone</tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L30"></a><tt class="py-lineno"> 30</tt>  <tt class="py-line">            <tt class="py-keyword">while</tt> <tt class="py-name">row</tt> <tt class="py-op">!=</tt> <tt class="py-name">None</tt><tt class="py-op">:</tt> </tt>
<a name="L31"></a><tt class="py-lineno"> 31</tt>  <tt class="py-line">                <tt class="py-keyword">yield</tt> <tt class="py-name">row</tt> </tt>
<a name="L32"></a><tt class="py-lineno"> 32</tt>  <tt class="py-line">                <tt class="py-name">row</tt> <tt class="py-op">=</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">conn</tt><tt class="py-op">.</tt><tt class="py-name">fetchone</tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L33"></a><tt class="py-lineno"> 33</tt>  <tt class="py-line">        <tt class="py-keyword">else</tt><tt class="py-op">:</tt> <tt class="py-keyword">return</tt> </tt>
</div></div><a name="L34"></a><tt class="py-lineno"> 34</tt>  <tt class="py-line"> </tt>
<a name="DBLogger"></a><div id="DBLogger-def"><a name="L35"></a><tt class="py-lineno"> 35</tt> <a class="py-toggle" href="#" id="DBLogger-toggle" onclick="return toggle('DBLogger');">-</a><tt class="py-line"><tt class="py-keyword">class</tt> <a class="py-def-name" href="killerbee.dblog.DBLogger-class.html">DBLogger</a><tt class="py-op">:</tt> </tt>
</div><div id="DBLogger-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="DBLogger-expanded"><a name="DBLogger.__init__"></a><div id="DBLogger.__init__-def"><a name="L36"></a><tt class="py-lineno"> 36</tt> <a class="py-toggle" href="#" id="DBLogger.__init__-toggle" onclick="return toggle('DBLogger.__init__');">-</a><tt class="py-line">    <tt class="py-keyword">def</tt> <a class="py-def-name" href="killerbee.dblog.DBLogger-class.html#__init__">__init__</a><tt class="py-op">(</tt><tt class="py-param">self</tt><tt class="py-op">,</tt> <tt class="py-param">datasource</tt><tt class="py-op">=</tt><tt class="py-name">None</tt><tt class="py-op">,</tt> <tt class="py-param">channel</tt><tt class="py-op">=</tt><tt class="py-name">None</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="DBLogger.__init__-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="DBLogger.__init__-expanded"><a name="L37"></a><tt class="py-lineno"> 37</tt>  <tt class="py-line">        <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">conn</tt> <tt class="py-op">=</tt> <tt class="py-name">None</tt> </tt>
<a name="L38"></a><tt class="py-lineno"> 38</tt>  <tt class="py-line"> </tt>
<a name="L39"></a><tt class="py-lineno"> 39</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-name">datasource</tt> <tt class="py-op">==</tt> <tt class="py-name">None</tt><tt class="py-op">:</tt> <tt class="py-comment">#datasource must be provided if DBLogger is desired</tt> </tt>
<a name="L40"></a><tt class="py-lineno"> 40</tt>  <tt class="py-line">            <tt class="py-keyword">return</tt> <tt class="py-name">None</tt> </tt>
<a name="L41"></a><tt class="py-lineno"> 41</tt>  <tt class="py-line"> </tt>
<a name="L42"></a><tt class="py-lineno"> 42</tt>  <tt class="py-line">        <tt class="py-name">self</tt><tt class="py-op">.</tt><tt id="link-14" class="py-name"><a title="killerbee.GoodFET.SymbolTable.db" class="py-name" href="#" onclick="return doclink('link-14', 'db', 'link-1');">db</a></tt> <tt class="py-op">=</tt> <tt class="py-name">None</tt> </tt>
<a name="L43"></a><tt class="py-lineno"> 43</tt>  <tt class="py-line">        <tt class="py-name">self</tt><tt class="py-op">.</tt><tt id="link-15" class="py-name" targets="Variable killerbee.KillerBee.channel=killerbee.KillerBee-class.html#channel"><a title="killerbee.KillerBee.channel" class="py-name" href="#" onclick="return doclink('link-15', 'channel', 'link-15');">channel</a></tt> <tt class="py-op">=</tt> <tt id="link-16" class="py-name"><a title="killerbee.KillerBee.channel" class="py-name" href="#" onclick="return doclink('link-16', 'channel', 'link-15');">channel</a></tt> </tt>
<a name="L44"></a><tt class="py-lineno"> 44</tt>  <tt class="py-line"> </tt>
<a name="L45"></a><tt class="py-lineno"> 45</tt>  <tt class="py-line">        <tt class="py-comment"># Initalize the connection</tt> </tt>
<a name="L46"></a><tt class="py-lineno"> 46</tt>  <tt class="py-line">        <tt class="py-keyword">try</tt><tt class="py-op">:</tt> </tt>
<a name="L47"></a><tt class="py-lineno"> 47</tt>  <tt class="py-line">            <tt class="py-name">self</tt><tt class="py-op">.</tt><tt id="link-17" class="py-name"><a title="killerbee.GoodFET.SymbolTable.db" class="py-name" href="#" onclick="return doclink('link-17', 'db', 'link-1');">db</a></tt> <tt class="py-op">=</tt> <tt class="py-name">MySQLdb</tt><tt class="py-op">.</tt><tt class="py-name">connect</tt><tt class="py-op">(</tt><tt class="py-name">user</tt><tt class="py-op">=</tt><tt id="link-18" class="py-name"><a title="killerbee.config.DB_USER" class="py-name" href="#" onclick="return doclink('link-18', 'DB_USER', 'link-3');">DB_USER</a></tt><tt class="py-op">,</tt> <tt class="py-name">passwd</tt><tt class="py-op">=</tt><tt id="link-19" class="py-name"><a title="killerbee.config.DB_PASS" class="py-name" href="#" onclick="return doclink('link-19', 'DB_PASS', 'link-4');">DB_PASS</a></tt><tt class="py-op">,</tt> <tt id="link-20" class="py-name"><a title="killerbee.GoodFET.SymbolTable.db" class="py-name" href="#" onclick="return doclink('link-20', 'db', 'link-1');">db</a></tt><tt class="py-op">=</tt><tt id="link-21" class="py-name"><a title="killerbee.config.DB_NAME" class="py-name" href="#" onclick="return doclink('link-21', 'DB_NAME', 'link-6');">DB_NAME</a></tt><tt class="py-op">,</tt> <tt class="py-name">host</tt><tt class="py-op">=</tt><tt id="link-22" class="py-name"><a title="killerbee.config.DB_HOST" class="py-name" href="#" onclick="return doclink('link-22', 'DB_HOST', 'link-7');">DB_HOST</a></tt><tt class="py-op">,</tt> <tt class="py-name">port</tt><tt class="py-op">=</tt><tt id="link-23" class="py-name"><a title="killerbee.config.DB_PORT" class="py-name" href="#" onclick="return doclink('link-23', 'DB_PORT', 'link-8');">DB_PORT</a></tt><tt class="py-op">)</tt> </tt>
<a name="L48"></a><tt class="py-lineno"> 48</tt>  <tt class="py-line">        <tt class="py-keyword">except</tt> <tt class="py-name">Exception</tt> <tt class="py-keyword">as</tt> <tt class="py-op">(</tt><tt class="py-name">errno</tt><tt class="py-op">,</tt> <tt class="py-name">errmsg</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
<a name="L49"></a><tt class="py-lineno"> 49</tt>  <tt class="py-line">            <tt class="py-keyword">raise</tt> <tt class="py-name">Exception</tt><tt class="py-op">(</tt><tt class="py-string">"DBLogger was unable to connect to the database: "</tt> \ </tt>
<a name="L50"></a><tt class="py-lineno"> 50</tt>  <tt class="py-line">                            <tt class="py-op">+</tt><tt class="py-string">"(error %d): %s (Note: connection values should be in config.py)."</tt> <tt class="py-op">%</tt> <tt class="py-op">(</tt><tt class="py-name">errno</tt><tt class="py-op">,</tt><tt class="py-name">errmsg</tt><tt class="py-op">)</tt><tt class="py-op">)</tt> </tt>
<a name="L51"></a><tt class="py-lineno"> 51</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt id="link-24" class="py-name"><a title="killerbee.GoodFET.SymbolTable.db" class="py-name" href="#" onclick="return doclink('link-24', 'db', 'link-1');">db</a></tt> <tt class="py-op">==</tt> <tt class="py-name">None</tt><tt class="py-op">:</tt> <tt class="py-comment">#this backup check may be redundant</tt> </tt>
<a name="L52"></a><tt class="py-lineno"> 52</tt>  <tt class="py-line">            <tt class="py-keyword">raise</tt> <tt class="py-name">Exception</tt><tt class="py-op">(</tt><tt class="py-string">"DBLogger: Unable to connect to database."</tt><tt class="py-op">)</tt> </tt>
<a name="L53"></a><tt class="py-lineno"> 53</tt>  <tt class="py-line">        <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">conn</tt> <tt class="py-op">=</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt id="link-25" class="py-name"><a title="killerbee.GoodFET.SymbolTable.db" class="py-name" href="#" onclick="return doclink('link-25', 'db', 'link-1');">db</a></tt><tt class="py-op">.</tt><tt class="py-name">cursor</tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L54"></a><tt class="py-lineno"> 54</tt>  <tt class="py-line"> </tt>
<a name="L55"></a><tt class="py-lineno"> 55</tt>  <tt class="py-line">        <tt class="py-comment"># Set the ds_id attribute to correspond to the requested data source name</tt> </tt>
<a name="L56"></a><tt class="py-lineno"> 56</tt>  <tt class="py-line">        <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">conn</tt><tt class="py-op">.</tt><tt id="link-26" class="py-name"><a title="killerbee.GoodFET.GoodFET.execute" class="py-name" href="#" onclick="return doclink('link-26', 'execute', 'link-12');">execute</a></tt><tt class="py-op">(</tt><tt class="py-string">"SELECT ds_id FROM datasources WHERE ds_name LIKE %s LIMIT 1"</tt><tt class="py-op">,</tt> <tt class="py-op">(</tt><tt class="py-name">datasource</tt><tt class="py-op">,</tt><tt class="py-op">)</tt><tt class="py-op">)</tt> </tt>
<a name="L57"></a><tt class="py-lineno"> 57</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">conn</tt><tt class="py-op">.</tt><tt class="py-name">rowcount</tt> <tt class="py-op">==</tt> <tt class="py-number">1</tt><tt class="py-op">:</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">ds_id</tt> <tt class="py-op">=</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">conn</tt><tt class="py-op">.</tt><tt class="py-name">fetchone</tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L58"></a><tt class="py-lineno"> 58</tt>  <tt class="py-line">        <tt class="py-keyword">else</tt><tt class="py-op">:</tt> <tt class="py-keyword">print</tt> <tt class="py-string">"No datasource found matching name:"</tt><tt class="py-op">,</tt> <tt class="py-name">datasource</tt> </tt>
</div><a name="L59"></a><tt class="py-lineno"> 59</tt>  <tt class="py-line"> </tt>
<a name="DBLogger.close"></a><div id="DBLogger.close-def"><a name="L60"></a><tt class="py-lineno"> 60</tt> <a class="py-toggle" href="#" id="DBLogger.close-toggle" onclick="return toggle('DBLogger.close');">-</a><tt class="py-line">    <tt class="py-keyword">def</tt> <a class="py-def-name" href="killerbee.dblog.DBLogger-class.html#close">close</a><tt class="py-op">(</tt><tt class="py-param">self</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="DBLogger.close-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="DBLogger.close-expanded"><a name="L61"></a><tt class="py-lineno"> 61</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">conn</tt> <tt class="py-op">!=</tt> <tt class="py-name">None</tt><tt class="py-op">:</tt> </tt>
<a name="L62"></a><tt class="py-lineno"> 62</tt>  <tt class="py-line">            <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">conn</tt><tt class="py-op">.</tt><tt id="link-27" class="py-name"><a title="killerbee.KillerBee.close
killerbee.daintree.DainTreeDumper.close
killerbee.daintree.DainTreeReader.close
killerbee.dblog.DBLogger.close
killerbee.dblog.DBReader.close
killerbee.dev_apimote.APIMOTE.close
killerbee.dev_freakduino.FREAKDUINO.close
killerbee.dev_rzusbstick.RZUSBSTICK.close
killerbee.dev_telosb.TELOSB.close
killerbee.dev_zigduino.ZIGDUINO.close
killerbee.pcapdump.PcapDumper.close
killerbee.pcapdump.PcapReader.close" class="py-name" href="#" onclick="return doclink('link-27', 'close', 'link-11');">close</a></tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L63"></a><tt class="py-lineno"> 63</tt>  <tt class="py-line">            <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">conn</tt> <tt class="py-op">=</tt> <tt class="py-name">None</tt> </tt>
</div><a name="L64"></a><tt class="py-lineno"> 64</tt>  <tt class="py-line"> </tt>
<a name="DBLogger.set_channel"></a><div id="DBLogger.set_channel-def"><a name="L65"></a><tt class="py-lineno"> 65</tt> <a class="py-toggle" href="#" id="DBLogger.set_channel-toggle" onclick="return toggle('DBLogger.set_channel');">-</a><tt class="py-line">    <tt class="py-keyword">def</tt> <a class="py-def-name" href="killerbee.dblog.DBLogger-class.html#set_channel">set_channel</a><tt class="py-op">(</tt><tt class="py-param">self</tt><tt class="py-op">,</tt> <tt class="py-param">chan</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="DBLogger.set_channel-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="DBLogger.set_channel-expanded"><a name="L66"></a><tt class="py-lineno"> 66</tt>  <tt class="py-line">        <tt class="py-name">self</tt><tt class="py-op">.</tt><tt id="link-28" class="py-name"><a title="killerbee.KillerBee.channel" class="py-name" href="#" onclick="return doclink('link-28', 'channel', 'link-15');">channel</a></tt> <tt class="py-op">=</tt> <tt class="py-name">chan</tt> </tt>
</div><a name="L67"></a><tt class="py-lineno"> 67</tt>  <tt class="py-line"> </tt>
<a name="DBLogger.add_packet"></a><div id="DBLogger.add_packet-def"><a name="L68"></a><tt class="py-lineno"> 68</tt> <a class="py-toggle" href="#" id="DBLogger.add_packet-toggle" onclick="return toggle('DBLogger.add_packet');">-</a><tt class="py-line">    <tt class="py-keyword">def</tt> <a class="py-def-name" href="killerbee.dblog.DBLogger-class.html#add_packet">add_packet</a><tt class="py-op">(</tt><tt class="py-param">self</tt><tt class="py-op">,</tt> <tt class="py-param">full</tt><tt class="py-op">=</tt><tt class="py-name">None</tt><tt class="py-op">,</tt> <tt class="py-param">scapy</tt><tt class="py-op">=</tt><tt class="py-name">None</tt><tt class="py-op">,</tt> </tt>
<a name="L69"></a><tt class="py-lineno"> 69</tt>  <tt class="py-line">                   <tt class="py-param">bytes</tt><tt class="py-op">=</tt><tt class="py-name">None</tt><tt class="py-op">,</tt> <tt class="py-param">rssi</tt><tt class="py-op">=</tt><tt class="py-name">None</tt><tt class="py-op">,</tt> <tt class="py-param">location</tt><tt class="py-op">=</tt><tt class="py-name">None</tt><tt class="py-op">,</tt> <tt class="py-param">datetime</tt><tt class="py-op">=</tt><tt class="py-name">None</tt><tt class="py-op">,</tt> <tt class="py-param">channel</tt><tt class="py-op">=</tt><tt class="py-name">None</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="DBLogger.add_packet-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="DBLogger.add_packet-expanded"><a name="L70"></a><tt class="py-lineno"> 70</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-op">(</tt><tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">conn</tt><tt class="py-op">==</tt><tt class="py-name">None</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> <tt class="py-keyword">raise</tt> <tt class="py-name">Exception</tt><tt class="py-op">(</tt><tt class="py-string">"DBLogger requires active connection status."</tt><tt class="py-op">)</tt> </tt>
<a name="L71"></a><tt class="py-lineno"> 71</tt>  <tt class="py-line">        <tt class="py-comment"># Use values in 'full' parameter to provide data for undefined other parameters</tt> </tt>
<a name="L72"></a><tt class="py-lineno"> 72</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-name">bytes</tt> <tt class="py-op">==</tt> <tt class="py-name">None</tt> <tt class="py-keyword">and</tt> <tt class="py-string">'bytes'</tt> <tt class="py-keyword">in</tt> <tt class="py-name">full</tt><tt class="py-op">:</tt> <tt class="py-name">bytes</tt> <tt class="py-op">=</tt> <tt class="py-name">full</tt><tt class="py-op">[</tt><tt class="py-string">'bytes'</tt><tt class="py-op">]</tt> </tt>
<a name="L73"></a><tt class="py-lineno"> 73</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-name">rssi</tt> <tt class="py-op">==</tt> <tt class="py-name">None</tt> <tt class="py-keyword">and</tt> <tt class="py-string">'rssi'</tt> <tt class="py-keyword">in</tt> <tt class="py-name">full</tt><tt class="py-op">:</tt> <tt class="py-name">rssi</tt> <tt class="py-op">=</tt> <tt class="py-name">full</tt><tt class="py-op">[</tt><tt class="py-string">'rssi'</tt><tt class="py-op">]</tt> </tt>
<a name="L74"></a><tt class="py-lineno"> 74</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-name">datetime</tt> <tt class="py-op">==</tt> <tt class="py-name">None</tt> <tt class="py-keyword">and</tt> <tt class="py-string">'datetime'</tt> <tt class="py-keyword">in</tt> <tt class="py-name">full</tt><tt class="py-op">:</tt> <tt class="py-name">datetime</tt> <tt class="py-op">=</tt> <tt class="py-name">full</tt><tt class="py-op">[</tt><tt class="py-string">'datetime'</tt><tt class="py-op">]</tt> </tt>
<a name="L75"></a><tt class="py-lineno"> 75</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-name">location</tt> <tt class="py-op">==</tt> <tt class="py-name">None</tt> <tt class="py-keyword">and</tt> <tt class="py-string">'location'</tt> <tt class="py-keyword">in</tt> <tt class="py-name">full</tt><tt class="py-op">:</tt> <tt class="py-name">location</tt> <tt class="py-op">=</tt> <tt class="py-name">full</tt><tt class="py-op">[</tt><tt class="py-string">'location'</tt><tt class="py-op">]</tt> </tt>
<a name="L76"></a><tt class="py-lineno"> 76</tt>  <tt class="py-line"> </tt>
<a name="L77"></a><tt class="py-lineno"> 77</tt>  <tt class="py-line">        <tt class="py-comment"># Get the location ID, or create one, if GPS data is available</tt> </tt>
<a name="L78"></a><tt class="py-lineno"> 78</tt>  <tt class="py-line">        <tt class="py-name">loc_id</tt> <tt class="py-op">=</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt id="link-29" class="py-name" targets="Method killerbee.dblog.DBLogger.add_location()=killerbee.dblog.DBLogger-class.html#add_location"><a title="killerbee.dblog.DBLogger.add_location" class="py-name" href="#" onclick="return doclink('link-29', 'add_location', 'link-29');">add_location</a></tt><tt class="py-op">(</tt><tt class="py-name">location</tt><tt class="py-op">)</tt> <tt class="py-keyword">if</tt> <tt class="py-name">location</tt> <tt class="py-keyword">is</tt> <tt class="py-keyword">not</tt> <tt class="py-name">None</tt> <tt class="py-keyword">else</tt> <tt class="py-name">None</tt> </tt>
<a name="L79"></a><tt class="py-lineno"> 79</tt>  <tt class="py-line"> </tt>
<a name="L80"></a><tt class="py-lineno"> 80</tt>  <tt class="py-line">        <tt class="py-comment"># Dissect the packet's bytes, using the Scapy'd version in parameter scapy if provided</tt> </tt>
<a name="L81"></a><tt class="py-lineno"> 81</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-name">scapy</tt> <tt class="py-op">==</tt> <tt class="py-name">None</tt><tt class="py-op">:</tt> </tt>
<a name="L82"></a><tt class="py-lineno"> 82</tt>  <tt class="py-line">            <tt class="py-comment"># Import Scapy extensions</tt> </tt>
<a name="L83"></a><tt class="py-lineno"> 83</tt>  <tt class="py-line">            <tt class="py-keyword">import</tt> <tt class="py-name">logging</tt> </tt>
<a name="L84"></a><tt class="py-lineno"> 84</tt>  <tt class="py-line">            <tt class="py-name">logging</tt><tt class="py-op">.</tt><tt class="py-name">getLogger</tt><tt class="py-op">(</tt><tt class="py-string">"scapy.runtime"</tt><tt class="py-op">)</tt><tt class="py-op">.</tt><tt class="py-name">setLevel</tt><tt class="py-op">(</tt><tt class="py-name">logging</tt><tt class="py-op">.</tt><tt class="py-name">ERROR</tt><tt class="py-op">)</tt> </tt>
<a name="L85"></a><tt class="py-lineno"> 85</tt>  <tt class="py-line">            <tt class="py-keyword">from</tt> <tt class="py-name">scapy</tt><tt class="py-op">.</tt><tt class="py-name">all</tt> <tt class="py-keyword">import</tt> <tt class="py-name">Dot15d4</tt> </tt>
<a name="L86"></a><tt class="py-lineno"> 86</tt>  <tt class="py-line">            <tt class="py-name">scapy</tt> <tt class="py-op">=</tt> <tt class="py-name">Dot15d4</tt><tt class="py-op">(</tt><tt class="py-name">bytes</tt><tt class="py-op">)</tt> </tt>
<a name="L87"></a><tt class="py-lineno"> 87</tt>  <tt class="py-line">        <tt class="py-comment">#from kbutils import hexdump</tt> </tt>
<a name="L88"></a><tt class="py-lineno"> 88</tt>  <tt class="py-line">        <tt class="py-comment">#print "Before", hexdump(bytes)</tt> </tt>
<a name="L89"></a><tt class="py-lineno"> 89</tt>  <tt class="py-line">        <tt class="py-comment">#print "Scapyd", hexdump(str(scapy))</tt> </tt>
<a name="L90"></a><tt class="py-lineno"> 90</tt>  <tt class="py-line">        <tt class="py-comment">#scapy.show2()</tt> </tt>
<a name="L91"></a><tt class="py-lineno"> 91</tt>  <tt class="py-line"> </tt>
<a name="L92"></a><tt class="py-lineno"> 92</tt>  <tt class="py-line">        <tt class="py-comment"># This try/except logic is dumb, but Scapy will just throw an exception if the field doesn't exist</tt> </tt>
<a name="L93"></a><tt class="py-lineno"> 93</tt>  <tt class="py-line">        <tt class="py-keyword">try</tt><tt class="py-op">:</tt> <tt class="py-name">srcaddr</tt> <tt class="py-op">=</tt> <tt class="py-name">scapy</tt><tt class="py-op">.</tt><tt class="py-name">src_addr</tt> </tt>
<a name="L94"></a><tt class="py-lineno"> 94</tt>  <tt class="py-line">        <tt class="py-keyword">except</tt><tt class="py-op">:</tt> <tt class="py-name">srcaddr</tt> <tt class="py-op">=</tt> <tt class="py-name">None</tt> </tt>
<a name="L95"></a><tt class="py-lineno"> 95</tt>  <tt class="py-line">        <tt class="py-keyword">try</tt><tt class="py-op">:</tt> <tt class="py-name">srcpan</tt> <tt class="py-op">=</tt> <tt class="py-name">scapy</tt><tt class="py-op">.</tt><tt class="py-name">src_panid</tt> </tt>
<a name="L96"></a><tt class="py-lineno"> 96</tt>  <tt class="py-line">        <tt class="py-keyword">except</tt><tt class="py-op">:</tt> <tt class="py-name">srcpan</tt> <tt class="py-op">=</tt> <tt class="py-name">None</tt> </tt>
<a name="L97"></a><tt class="py-lineno"> 97</tt>  <tt class="py-line">        <tt class="py-name">srcdevid</tt> <tt class="py-op">=</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt id="link-30" class="py-name" targets="Method killerbee.dblog.DBLogger.add_device()=killerbee.dblog.DBLogger-class.html#add_device"><a title="killerbee.dblog.DBLogger.add_device" class="py-name" href="#" onclick="return doclink('link-30', 'add_device', 'link-30');">add_device</a></tt><tt class="py-op">(</tt><tt class="py-name">srcaddr</tt><tt class="py-op">,</tt> <tt class="py-name">srcpan</tt><tt class="py-op">)</tt> </tt>
<a name="L98"></a><tt class="py-lineno"> 98</tt>  <tt class="py-line">        <tt class="py-keyword">try</tt><tt class="py-op">:</tt> <tt class="py-name">destaddr</tt> <tt class="py-op">=</tt> <tt class="py-name">scapy</tt><tt class="py-op">.</tt><tt class="py-name">dest_addr</tt> </tt>
<a name="L99"></a><tt class="py-lineno"> 99</tt>  <tt class="py-line">        <tt class="py-keyword">except</tt><tt class="py-op">:</tt> <tt class="py-name">destaddr</tt> <tt class="py-op">=</tt> <tt class="py-name">None</tt> </tt>
<a name="L100"></a><tt class="py-lineno">100</tt>  <tt class="py-line">        <tt class="py-keyword">try</tt><tt class="py-op">:</tt> <tt class="py-name">destpanid</tt> <tt class="py-op">=</tt> <tt class="py-name">scapy</tt><tt class="py-op">.</tt><tt class="py-name">dest_panid</tt> </tt>
<a name="L101"></a><tt class="py-lineno">101</tt>  <tt class="py-line">        <tt class="py-keyword">except</tt><tt class="py-op">:</tt> <tt class="py-name">destpanid</tt> <tt class="py-op">=</tt> <tt class="py-name">None</tt> </tt>
<a name="L102"></a><tt class="py-lineno">102</tt>  <tt class="py-line">        <tt class="py-name">destdevid</tt> <tt class="py-op">=</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt id="link-31" class="py-name"><a title="killerbee.dblog.DBLogger.add_device" class="py-name" href="#" onclick="return doclink('link-31', 'add_device', 'link-30');">add_device</a></tt><tt class="py-op">(</tt><tt class="py-name">destaddr</tt><tt class="py-op">,</tt> <tt class="py-name">destpanid</tt><tt class="py-op">)</tt> </tt>
<a name="L103"></a><tt class="py-lineno">103</tt>  <tt class="py-line"> </tt>
<a name="L104"></a><tt class="py-lineno">104</tt>  <tt class="py-line">        <tt class="py-name">sql</tt> <tt class="py-op">=</tt> <tt class="py-op">[</tt><tt class="py-op">]</tt> </tt>
<a name="L105"></a><tt class="py-lineno">105</tt>  <tt class="py-line">        <tt class="py-name">sql</tt><tt class="py-op">.</tt><tt class="py-name">append</tt><tt class="py-op">(</tt><tt class="py-string">"ds_id=%d"</tt> <tt class="py-op">%</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">ds_id</tt><tt class="py-op">)</tt> </tt>
<a name="L106"></a><tt class="py-lineno">106</tt>  <tt class="py-line">        <tt class="py-name">sql</tt><tt class="py-op">.</tt><tt class="py-name">append</tt><tt class="py-op">(</tt><tt class="py-string">"db_datetime=NOW()"</tt><tt class="py-op">)</tt> </tt>
<a name="L107"></a><tt class="py-lineno">107</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-name">datetime</tt> <tt class="py-op">!=</tt> <tt class="py-name">None</tt><tt class="py-op">:</tt> <tt class="py-name">sql</tt><tt class="py-op">.</tt><tt class="py-name">append</tt><tt class="py-op">(</tt><tt class="py-string">"cap_datetime='%s'"</tt> <tt class="py-op">%</tt> <tt class="py-name">str</tt><tt class="py-op">(</tt><tt class="py-name">datetime</tt><tt class="py-op">)</tt><tt class="py-op">)</tt> </tt>
<a name="L108"></a><tt class="py-lineno">108</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt id="link-32" class="py-name"><a title="killerbee.KillerBee.channel" class="py-name" href="#" onclick="return doclink('link-32', 'channel', 'link-15');">channel</a></tt> <tt class="py-op">!=</tt> <tt class="py-name">None</tt><tt class="py-op">:</tt> <tt class="py-name">sql</tt><tt class="py-op">.</tt><tt class="py-name">append</tt><tt class="py-op">(</tt><tt class="py-string">"channel=%d"</tt> <tt class="py-op">%</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt id="link-33" class="py-name"><a title="killerbee.KillerBee.channel" class="py-name" href="#" onclick="return doclink('link-33', 'channel', 'link-15');">channel</a></tt><tt class="py-op">)</tt> </tt>
<a name="L109"></a><tt class="py-lineno">109</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-name">srcdevid</tt> <tt class="py-op">!=</tt> <tt class="py-name">None</tt><tt class="py-op">:</tt> <tt class="py-name">sql</tt><tt class="py-op">.</tt><tt class="py-name">append</tt><tt class="py-op">(</tt><tt class="py-string">"source=%d"</tt> <tt class="py-op">%</tt> <tt class="py-name">srcdevid</tt><tt class="py-op">)</tt> </tt>
<a name="L110"></a><tt class="py-lineno">110</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-name">destdevid</tt> <tt class="py-op">!=</tt> <tt class="py-name">None</tt><tt class="py-op">:</tt> <tt class="py-name">sql</tt><tt class="py-op">.</tt><tt class="py-name">append</tt><tt class="py-op">(</tt><tt class="py-string">"dest=%d"</tt> <tt class="py-op">%</tt> <tt class="py-name">destdevid</tt><tt class="py-op">)</tt> </tt>
<a name="L111"></a><tt class="py-lineno">111</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-name">rssi</tt> <tt class="py-op">!=</tt> <tt class="py-name">None</tt><tt class="py-op">:</tt> <tt class="py-name">sql</tt><tt class="py-op">.</tt><tt class="py-name">append</tt><tt class="py-op">(</tt><tt class="py-string">"rssi=%d"</tt> <tt class="py-op">%</tt> <tt class="py-name">rssi</tt><tt class="py-op">)</tt> </tt>
<a name="L112"></a><tt class="py-lineno">112</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-name">loc_id</tt> <tt class="py-op">!=</tt> <tt class="py-name">None</tt><tt class="py-op">:</tt> <tt class="py-name">sql</tt><tt class="py-op">.</tt><tt class="py-name">append</tt><tt class="py-op">(</tt><tt class="py-string">"loc_id=%d"</tt> <tt class="py-op">%</tt> <tt class="py-name">loc_id</tt><tt class="py-op">)</tt> </tt>
<a name="L113"></a><tt class="py-lineno">113</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt id="link-34" class="py-name"><a title="killerbee.KillerBee.channel" class="py-name" href="#" onclick="return doclink('link-34', 'channel', 'link-15');">channel</a></tt> <tt class="py-op">!=</tt> <tt class="py-name">None</tt><tt class="py-op">:</tt> <tt class="py-name">sql</tt><tt class="py-op">.</tt><tt class="py-name">append</tt><tt class="py-op">(</tt><tt class="py-string">"channel=%d"</tt> <tt class="py-op">%</tt> <tt id="link-35" class="py-name"><a title="killerbee.KillerBee.channel" class="py-name" href="#" onclick="return doclink('link-35', 'channel', 'link-15');">channel</a></tt><tt class="py-op">)</tt> </tt>
<a name="L114"></a><tt class="py-lineno">114</tt>  <tt class="py-line">        <tt class="py-name">sql</tt><tt class="py-op">.</tt><tt class="py-name">append</tt><tt class="py-op">(</tt><tt class="py-string">"fcf_panidcompress=%d"</tt> <tt class="py-op">%</tt> <tt class="py-name">scapy</tt><tt class="py-op">.</tt><tt class="py-name">fcf_panidcompress</tt><tt class="py-op">)</tt> </tt>
<a name="L115"></a><tt class="py-lineno">115</tt>  <tt class="py-line">        <tt class="py-name">sql</tt><tt class="py-op">.</tt><tt class="py-name">append</tt><tt class="py-op">(</tt><tt class="py-string">"fcf_ackreq=%d"</tt> <tt class="py-op">%</tt> <tt class="py-name">scapy</tt><tt class="py-op">.</tt><tt class="py-name">fcf_ackreq</tt><tt class="py-op">)</tt> </tt>
<a name="L116"></a><tt class="py-lineno">116</tt>  <tt class="py-line">        <tt class="py-name">sql</tt><tt class="py-op">.</tt><tt class="py-name">append</tt><tt class="py-op">(</tt><tt class="py-string">"fcf_pending=%d"</tt> <tt class="py-op">%</tt> <tt class="py-name">scapy</tt><tt class="py-op">.</tt><tt class="py-name">fcf_pending</tt><tt class="py-op">)</tt> </tt>
<a name="L117"></a><tt class="py-lineno">117</tt>  <tt class="py-line">        <tt class="py-name">sql</tt><tt class="py-op">.</tt><tt class="py-name">append</tt><tt class="py-op">(</tt><tt class="py-string">"fcf_security=%d"</tt> <tt class="py-op">%</tt> <tt class="py-name">scapy</tt><tt class="py-op">.</tt><tt class="py-name">fcf_security</tt><tt class="py-op">)</tt> </tt>
<a name="L118"></a><tt class="py-lineno">118</tt>  <tt class="py-line">        <tt class="py-name">sql</tt><tt class="py-op">.</tt><tt class="py-name">append</tt><tt class="py-op">(</tt><tt class="py-string">"fcf_frametype=%d"</tt> <tt class="py-op">%</tt> <tt class="py-name">scapy</tt><tt class="py-op">.</tt><tt class="py-name">fcf_frametype</tt><tt class="py-op">)</tt> </tt>
<a name="L119"></a><tt class="py-lineno">119</tt>  <tt class="py-line">        <tt class="py-name">sql</tt><tt class="py-op">.</tt><tt class="py-name">append</tt><tt class="py-op">(</tt><tt class="py-string">"fcf_srcaddrmode=%d"</tt> <tt class="py-op">%</tt> <tt class="py-name">scapy</tt><tt class="py-op">.</tt><tt class="py-name">fcf_srcaddrmode</tt><tt class="py-op">)</tt> </tt>
<a name="L120"></a><tt class="py-lineno">120</tt>  <tt class="py-line">        <tt class="py-name">sql</tt><tt class="py-op">.</tt><tt class="py-name">append</tt><tt class="py-op">(</tt><tt class="py-string">"fcf_framever=%d"</tt> <tt class="py-op">%</tt> <tt class="py-name">scapy</tt><tt class="py-op">.</tt><tt class="py-name">fcf_framever</tt><tt class="py-op">)</tt> </tt>
<a name="L121"></a><tt class="py-lineno">121</tt>  <tt class="py-line">        <tt class="py-name">sql</tt><tt class="py-op">.</tt><tt class="py-name">append</tt><tt class="py-op">(</tt><tt class="py-string">"fcf_destaddrmode=%d"</tt> <tt class="py-op">%</tt> <tt class="py-name">scapy</tt><tt class="py-op">.</tt><tt class="py-name">fcf_destaddrmode</tt><tt class="py-op">)</tt> </tt>
<a name="L122"></a><tt class="py-lineno">122</tt>  <tt class="py-line">        <tt class="py-name">sql</tt><tt class="py-op">.</tt><tt class="py-name">append</tt><tt class="py-op">(</tt><tt class="py-string">"seqnum=%d"</tt> <tt class="py-op">%</tt> <tt class="py-name">scapy</tt><tt class="py-op">.</tt><tt class="py-name">seqnum</tt><tt class="py-op">)</tt> </tt>
<a name="L123"></a><tt class="py-lineno">123</tt>  <tt class="py-line">        <tt class="py-comment"># adding the bytes of the packet are handled in the insert method b/c they are binary</tt> </tt>
<a name="L124"></a><tt class="py-lineno">124</tt>  <tt class="py-line">        <tt class="py-keyword">return</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt id="link-36" class="py-name" targets="Method killerbee.dblog.DBLogger.insert()=killerbee.dblog.DBLogger-class.html#insert"><a title="killerbee.dblog.DBLogger.insert" class="py-name" href="#" onclick="return doclink('link-36', 'insert', 'link-36');">insert</a></tt><tt class="py-op">(</tt><tt class="py-string">' '</tt><tt class="py-op">.</tt><tt class="py-name">join</tt><tt class="py-op">(</tt><tt class="py-op">[</tt><tt class="py-string">'INSERT INTO packets SET'</tt><tt class="py-op">,</tt> <tt class="py-string">', '</tt><tt class="py-op">.</tt><tt class="py-name">join</tt><tt class="py-op">(</tt><tt class="py-name">sql</tt><tt class="py-op">)</tt><tt class="py-op">]</tt><tt class="py-op">)</tt><tt class="py-op">,</tt> <tt class="py-name">packetbytes</tt><tt class="py-op">=</tt><tt class="py-name">bytes</tt><tt class="py-op">)</tt> </tt>
</div><a name="L125"></a><tt class="py-lineno">125</tt>  <tt class="py-line"> </tt>
<a name="DBLogger.add_location"></a><div id="DBLogger.add_location-def"><a name="L126"></a><tt class="py-lineno">126</tt> <a class="py-toggle" href="#" id="DBLogger.add_location-toggle" onclick="return toggle('DBLogger.add_location');">-</a><tt class="py-line">    <tt class="py-keyword">def</tt> <a class="py-def-name" href="killerbee.dblog.DBLogger-class.html#add_location">add_location</a><tt class="py-op">(</tt><tt class="py-param">self</tt><tt class="py-op">,</tt> <tt class="py-param">location</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="DBLogger.add_location-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="DBLogger.add_location-expanded"><a name="L127"></a><tt class="py-lineno">127</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-op">(</tt><tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">conn</tt><tt class="py-op">==</tt><tt class="py-name">None</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> <tt class="py-keyword">raise</tt> <tt class="py-name">Exception</tt><tt class="py-op">(</tt><tt class="py-string">"DBLogger requires active connection status."</tt><tt class="py-op">)</tt> </tt>
<a name="L128"></a><tt class="py-lineno">128</tt>  <tt class="py-line">        <tt class="py-op">(</tt><tt class="py-name">lon</tt><tt class="py-op">,</tt> <tt class="py-name">lat</tt><tt class="py-op">,</tt> <tt class="py-name">alt</tt><tt class="py-op">)</tt> <tt class="py-op">=</tt> <tt class="py-name">location</tt> </tt>
<a name="L129"></a><tt class="py-lineno">129</tt>  <tt class="py-line">        <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">conn</tt><tt class="py-op">.</tt><tt id="link-37" class="py-name"><a title="killerbee.GoodFET.GoodFET.execute" class="py-name" href="#" onclick="return doclink('link-37', 'execute', 'link-12');">execute</a></tt><tt class="py-op">(</tt><tt class="py-string">"SELECT loc_id FROM locations WHERE %s AND %s AND %s LIMIT 1"</tt> <tt class="py-op">%</tt>          \ </tt>
<a name="L130"></a><tt class="py-lineno">130</tt>  <tt class="py-line">                            <tt class="py-op">(</tt> <tt class="py-op">(</tt><tt class="py-string">"longitude = '%f'"</tt> <tt class="py-op">%</tt> <tt class="py-name">lon</tt><tt class="py-op">)</tt> <tt class="py-keyword">if</tt> <tt class="py-name">lon</tt> <tt class="py-op">!=</tt> <tt class="py-name">None</tt> <tt class="py-keyword">else</tt> <tt class="py-string">"longitude IS NULL"</tt> <tt class="py-op">,</tt> \ </tt>
<a name="L131"></a><tt class="py-lineno">131</tt>  <tt class="py-line">                              <tt class="py-op">(</tt><tt class="py-string">"latitude = '%f'"</tt> <tt class="py-op">%</tt> <tt class="py-name">lat</tt><tt class="py-op">)</tt> <tt class="py-keyword">if</tt> <tt class="py-name">lat</tt> <tt class="py-op">!=</tt> <tt class="py-name">None</tt> <tt class="py-keyword">else</tt> <tt class="py-string">"latitude IS NULL"</tt>   <tt class="py-op">,</tt> \ </tt>
<a name="L132"></a><tt class="py-lineno">132</tt>  <tt class="py-line">                              <tt class="py-op">(</tt><tt class="py-string">"elevation = '%f'"</tt> <tt class="py-op">%</tt> <tt class="py-name">alt</tt><tt class="py-op">)</tt> <tt class="py-keyword">if</tt> <tt class="py-name">alt</tt> <tt class="py-op">!=</tt> <tt class="py-name">None</tt> <tt class="py-keyword">else</tt> <tt class="py-string">"elevation IS NULL"</tt>  <tt class="py-op">)</tt><tt class="py-op">)</tt> </tt>
<a name="L133"></a><tt class="py-lineno">133</tt>  <tt class="py-line">        <tt class="py-name">res</tt> <tt class="py-op">=</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">conn</tt><tt class="py-op">.</tt><tt class="py-name">fetchone</tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L134"></a><tt class="py-lineno">134</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-op">(</tt><tt class="py-name">res</tt> <tt class="py-op">!=</tt> <tt class="py-name">None</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
<a name="L135"></a><tt class="py-lineno">135</tt>  <tt class="py-line">            <tt class="py-keyword">return</tt> <tt class="py-name">res</tt> <tt class="py-comment">#location already in db, return loc_id</tt> </tt>
<a name="L136"></a><tt class="py-lineno">136</tt>  <tt class="py-line">        <tt class="py-keyword">else</tt><tt class="py-op">:</tt> </tt>
<a name="L137"></a><tt class="py-lineno">137</tt>  <tt class="py-line">            <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">conn</tt><tt class="py-op">.</tt><tt id="link-38" class="py-name"><a title="killerbee.GoodFET.GoodFET.execute" class="py-name" href="#" onclick="return doclink('link-38', 'execute', 'link-12');">execute</a></tt><tt class="py-op">(</tt><tt class="py-string">"INSERT INTO locations SET %s, %s, %s"</tt> <tt class="py-op">%</tt>                            \ </tt>
<a name="L138"></a><tt class="py-lineno">138</tt>  <tt class="py-line">                            <tt class="py-op">(</tt> <tt class="py-op">(</tt><tt class="py-string">"longitude = '%f'"</tt> <tt class="py-op">%</tt> <tt class="py-name">lon</tt><tt class="py-op">)</tt> <tt class="py-keyword">if</tt> <tt class="py-name">lon</tt> <tt class="py-op">!=</tt> <tt class="py-name">None</tt> <tt class="py-keyword">else</tt> <tt class="py-string">"longitude = NULL"</tt> <tt class="py-op">,</tt> \ </tt>
<a name="L139"></a><tt class="py-lineno">139</tt>  <tt class="py-line">                              <tt class="py-op">(</tt><tt class="py-string">"latitude = '%f'"</tt> <tt class="py-op">%</tt> <tt class="py-name">lat</tt><tt class="py-op">)</tt> <tt class="py-keyword">if</tt> <tt class="py-name">lat</tt> <tt class="py-op">!=</tt> <tt class="py-name">None</tt> <tt class="py-keyword">else</tt> <tt class="py-string">"latitude = NULL"</tt>   <tt class="py-op">,</tt> \ </tt>
<a name="L140"></a><tt class="py-lineno">140</tt>  <tt class="py-line">                              <tt class="py-op">(</tt><tt class="py-string">"elevation = '%f'"</tt> <tt class="py-op">%</tt> <tt class="py-name">alt</tt><tt class="py-op">)</tt> <tt class="py-keyword">if</tt> <tt class="py-name">alt</tt> <tt class="py-op">!=</tt> <tt class="py-name">None</tt> <tt class="py-keyword">else</tt> <tt class="py-string">"elevation = NULL"</tt>  <tt class="py-op">)</tt><tt class="py-op">)</tt> </tt>
<a name="L141"></a><tt class="py-lineno">141</tt>  <tt class="py-line">            <tt class="py-keyword">if</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">conn</tt><tt class="py-op">.</tt><tt class="py-name">rowcount</tt> <tt class="py-op">!=</tt> <tt class="py-number">1</tt><tt class="py-op">:</tt> <tt class="py-keyword">raise</tt> <tt class="py-name">Exception</tt><tt class="py-op">(</tt><tt class="py-string">"Location insert did not succeed."</tt><tt class="py-op">)</tt> </tt>
<a name="L142"></a><tt class="py-lineno">142</tt>  <tt class="py-line">            <tt class="py-name">self</tt><tt class="py-op">.</tt><tt id="link-39" class="py-name"><a title="killerbee.GoodFET.SymbolTable.db" class="py-name" href="#" onclick="return doclink('link-39', 'db', 'link-1');">db</a></tt><tt class="py-op">.</tt><tt class="py-name">commit</tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L143"></a><tt class="py-lineno">143</tt>  <tt class="py-line">            <tt class="py-keyword">return</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">conn</tt><tt class="py-op">.</tt><tt class="py-name">lastrowid</tt> </tt>
</div><a name="L144"></a><tt class="py-lineno">144</tt>  <tt class="py-line"> </tt>
<a name="DBLogger.add_device"></a><div id="DBLogger.add_device-def"><a name="L145"></a><tt class="py-lineno">145</tt> <a class="py-toggle" href="#" id="DBLogger.add_device-toggle" onclick="return toggle('DBLogger.add_device');">-</a><tt class="py-line">    <tt class="py-keyword">def</tt> <a class="py-def-name" href="killerbee.dblog.DBLogger-class.html#add_device">add_device</a><tt class="py-op">(</tt><tt class="py-param">self</tt><tt class="py-op">,</tt> <tt class="py-param">shortaddr</tt><tt class="py-op">,</tt> <tt class="py-param">panid</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="DBLogger.add_device-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="DBLogger.add_device-expanded"><a name="L146"></a><tt class="py-lineno">146</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-op">(</tt><tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">conn</tt><tt class="py-op">==</tt><tt class="py-name">None</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> <tt class="py-keyword">raise</tt> <tt class="py-name">Exception</tt><tt class="py-op">(</tt><tt class="py-string">"DBLogger requires active connection status."</tt><tt class="py-op">)</tt> </tt>
<a name="L147"></a><tt class="py-lineno">147</tt>  <tt class="py-line">        <tt class="py-comment">#print "DEBUG: Looking for addr, panid:", shortaddr, panid</tt> </tt>
<a name="L148"></a><tt class="py-lineno">148</tt>  <tt class="py-line">        <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">conn</tt><tt class="py-op">.</tt><tt id="link-40" class="py-name"><a title="killerbee.GoodFET.GoodFET.execute" class="py-name" href="#" onclick="return doclink('link-40', 'execute', 'link-12');">execute</a></tt><tt class="py-op">(</tt><tt class="py-string">"SELECT dev_id FROM devices WHERE %s AND %s LIMIT 1"</tt> <tt class="py-op">%</tt> \ </tt>
<a name="L149"></a><tt class="py-lineno">149</tt>  <tt class="py-line">                            <tt class="py-op">(</tt> <tt class="py-op">(</tt><tt class="py-string">"short_addr = '%04x'"</tt> <tt class="py-op">%</tt> <tt class="py-name">shortaddr</tt><tt class="py-op">)</tt> <tt class="py-keyword">if</tt> <tt class="py-name">shortaddr</tt> <tt class="py-op">!=</tt> <tt class="py-name">None</tt> <tt class="py-keyword">else</tt> <tt class="py-string">"short_addr IS NULL"</tt> <tt class="py-op">,</tt> \ </tt>
<a name="L150"></a><tt class="py-lineno">150</tt>  <tt class="py-line">                              <tt class="py-op">(</tt><tt class="py-string">"pan_id = '%04x'"</tt> <tt class="py-op">%</tt> <tt class="py-name">panid</tt><tt class="py-op">)</tt> <tt class="py-keyword">if</tt> <tt class="py-name">panid</tt> <tt class="py-op">!=</tt> <tt class="py-name">None</tt> <tt class="py-keyword">else</tt> <tt class="py-string">"pan_id IS NULL"</tt> <tt class="py-op">)</tt><tt class="py-op">)</tt> </tt>
<a name="L151"></a><tt class="py-lineno">151</tt>  <tt class="py-line">        <tt class="py-name">res</tt> <tt class="py-op">=</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">conn</tt><tt class="py-op">.</tt><tt class="py-name">fetchone</tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L152"></a><tt class="py-lineno">152</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-op">(</tt><tt class="py-name">res</tt> <tt class="py-op">!=</tt> <tt class="py-name">None</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
<a name="L153"></a><tt class="py-lineno">153</tt>  <tt class="py-line">            <tt class="py-keyword">return</tt> <tt class="py-name">res</tt> <tt class="py-comment">#device already exists</tt> </tt>
<a name="L154"></a><tt class="py-lineno">154</tt>  <tt class="py-line">        <tt class="py-keyword">else</tt><tt class="py-op">:</tt> </tt>
<a name="L155"></a><tt class="py-lineno">155</tt>  <tt class="py-line">            <tt class="py-comment">#print "Found New Device: %04x on %04x." % (shortaddr, panid) #TODO make print when verbose only</tt> </tt>
<a name="L156"></a><tt class="py-lineno">156</tt>  <tt class="py-line">            <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">conn</tt><tt class="py-op">.</tt><tt id="link-41" class="py-name"><a title="killerbee.GoodFET.GoodFET.execute" class="py-name" href="#" onclick="return doclink('link-41', 'execute', 'link-12');">execute</a></tt><tt class="py-op">(</tt><tt class="py-string">"INSERT INTO devices SET %s, %s"</tt> <tt class="py-op">%</tt> \ </tt>
<a name="L157"></a><tt class="py-lineno">157</tt>  <tt class="py-line">                             <tt class="py-op">(</tt><tt class="py-op">(</tt><tt class="py-string">"short_addr = '%04x'"</tt> <tt class="py-op">%</tt> <tt class="py-name">shortaddr</tt><tt class="py-op">)</tt> <tt class="py-keyword">if</tt> <tt class="py-name">shortaddr</tt> <tt class="py-op">!=</tt> <tt class="py-name">None</tt> <tt class="py-keyword">else</tt> <tt class="py-string">"short_addr = NULL"</tt> <tt class="py-op">,</tt> \ </tt>
<a name="L158"></a><tt class="py-lineno">158</tt>  <tt class="py-line">                              <tt class="py-op">(</tt><tt class="py-string">"pan_id = '%04x'"</tt> <tt class="py-op">%</tt> <tt class="py-name">panid</tt><tt class="py-op">)</tt> <tt class="py-keyword">if</tt> <tt class="py-name">panid</tt> <tt class="py-op">!=</tt> <tt class="py-name">None</tt> <tt class="py-keyword">else</tt> <tt class="py-string">"pan_id = NULL"</tt> <tt class="py-op">)</tt><tt class="py-op">)</tt> </tt>
<a name="L159"></a><tt class="py-lineno">159</tt>  <tt class="py-line">            <tt class="py-keyword">if</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">conn</tt><tt class="py-op">.</tt><tt class="py-name">rowcount</tt> <tt class="py-op">!=</tt> <tt class="py-number">1</tt><tt class="py-op">:</tt> <tt class="py-keyword">raise</tt> <tt class="py-name">Exception</tt><tt class="py-op">(</tt><tt class="py-string">"Device insert did not succeed."</tt><tt class="py-op">)</tt> </tt>
<a name="L160"></a><tt class="py-lineno">160</tt>  <tt class="py-line">            <tt class="py-name">self</tt><tt class="py-op">.</tt><tt id="link-42" class="py-name"><a title="killerbee.GoodFET.SymbolTable.db" class="py-name" href="#" onclick="return doclink('link-42', 'db', 'link-1');">db</a></tt><tt class="py-op">.</tt><tt class="py-name">commit</tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L161"></a><tt class="py-lineno">161</tt>  <tt class="py-line">            <tt class="py-keyword">return</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">conn</tt><tt class="py-op">.</tt><tt class="py-name">lastrowid</tt> </tt>
</div><a name="L162"></a><tt class="py-lineno">162</tt>  <tt class="py-line"> </tt>
<a name="DBLogger.insert"></a><div id="DBLogger.insert-def"><a name="L163"></a><tt class="py-lineno">163</tt> <a class="py-toggle" href="#" id="DBLogger.insert-toggle" onclick="return toggle('DBLogger.insert');">-</a><tt class="py-line">    <tt class="py-keyword">def</tt> <a class="py-def-name" href="killerbee.dblog.DBLogger-class.html#insert">insert</a><tt class="py-op">(</tt><tt class="py-param">self</tt><tt class="py-op">,</tt> <tt class="py-param">sql</tt><tt class="py-op">,</tt> <tt class="py-param">packetbytes</tt><tt class="py-op">=</tt><tt class="py-name">None</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="DBLogger.insert-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="DBLogger.insert-expanded"><a name="L164"></a><tt class="py-lineno">164</tt>  <tt class="py-line">        <tt class="py-name">params</tt> <tt class="py-op">=</tt> <tt class="py-name">None</tt> </tt>
<a name="L165"></a><tt class="py-lineno">165</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-name">packetbytes</tt> <tt class="py-op">!=</tt> <tt class="py-name">None</tt><tt class="py-op">:</tt> </tt>
<a name="L166"></a><tt class="py-lineno">166</tt>  <tt class="py-line">            <tt class="py-name">sql</tt> <tt class="py-op">=</tt> <tt class="py-name">sql</tt> <tt class="py-op">+</tt> <tt class="py-string">", packetbytes=%s"</tt> </tt>
<a name="L167"></a><tt class="py-lineno">167</tt>  <tt class="py-line">            <tt class="py-name">params</tt> <tt class="py-op">=</tt> <tt class="py-op">(</tt><tt class="py-name">MySQLdb</tt><tt class="py-op">.</tt><tt class="py-name">Binary</tt><tt class="py-op">(</tt><tt class="py-name">packetbytes</tt><tt class="py-op">)</tt><tt class="py-op">,</tt> <tt class="py-op">)</tt> </tt>
<a name="L168"></a><tt class="py-lineno">168</tt>  <tt class="py-line">        <tt class="py-comment">#print "INSERTING SQL: ", sql</tt> </tt>
<a name="L169"></a><tt class="py-lineno">169</tt>  <tt class="py-line">        <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">conn</tt><tt class="py-op">.</tt><tt id="link-43" class="py-name"><a title="killerbee.GoodFET.GoodFET.execute" class="py-name" href="#" onclick="return doclink('link-43', 'execute', 'link-12');">execute</a></tt><tt class="py-op">(</tt><tt class="py-name">sql</tt><tt class="py-op">,</tt> <tt class="py-name">params</tt><tt class="py-op">)</tt> </tt>
<a name="L170"></a><tt class="py-lineno">170</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">conn</tt><tt class="py-op">.</tt><tt class="py-name">rowcount</tt> <tt class="py-op">!=</tt> <tt class="py-number">1</tt><tt class="py-op">:</tt> <tt class="py-keyword">raise</tt> <tt class="py-name">Exception</tt><tt class="py-op">(</tt><tt class="py-string">"DBLogger: Insert did not succeed."</tt><tt class="py-op">)</tt> </tt>
<a name="L171"></a><tt class="py-lineno">171</tt>  <tt class="py-line">        <tt class="py-name">self</tt><tt class="py-op">.</tt><tt id="link-44" class="py-name"><a title="killerbee.GoodFET.SymbolTable.db" class="py-name" href="#" onclick="return doclink('link-44', 'db', 'link-1');">db</a></tt><tt class="py-op">.</tt><tt class="py-name">commit</tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L172"></a><tt class="py-lineno">172</tt>  <tt class="py-line">        <tt class="py-keyword">return</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">conn</tt><tt class="py-op">.</tt><tt class="py-name">lastrowid</tt> </tt>
</div></div><a name="L173"></a><tt class="py-lineno">173</tt>  <tt class="py-line"> </tt><script type="text/javascript">
<!--
expandto(location.href);
// -->
</script>
</pre>
<br />
<!-- ==================== NAVIGATION BAR ==================== -->
<table class="navbar" border="0" width="100%" cellpadding="0"
       bgcolor="#a0c0ff" cellspacing="0">
  <tr valign="middle">
  <!-- Home link -->
      <th>&nbsp;&nbsp;&nbsp;<a
        href="killerbee-module.html">Home</a>&nbsp;&nbsp;&nbsp;</th>

  <!-- Tree link -->
      <th>&nbsp;&nbsp;&nbsp;<a
        href="module-tree.html">Trees</a>&nbsp;&nbsp;&nbsp;</th>

  <!-- Index link -->
      <th>&nbsp;&nbsp;&nbsp;<a
        href="identifier-index.html">Indices</a>&nbsp;&nbsp;&nbsp;</th>

  <!-- Help link -->
      <th>&nbsp;&nbsp;&nbsp;<a
        href="help.html">Help</a>&nbsp;&nbsp;&nbsp;</th>

  <!-- Project homepage -->
      <th class="navbar" align="right" width="100%">
        <table border="0" cellpadding="0" cellspacing="0">
          <tr><th class="navbar" align="center"
            ><a class="navbar" target="_top" href="http://code.google.com/p/killerbee/">KillerBee</a></th>
          </tr></table></th>
  </tr>
</table>
<table border="0" cellpadding="0" cellspacing="0" width="100%%">
  <tr>
    <td align="left" class="footer">
    Generated by Epydoc 3.0.1 on Tue Sep  3 22:31:33 2013
    </td>
    <td align="right" class="footer">
      <a target="mainFrame" href="http://epydoc.sourceforge.net"
        >http://epydoc.sourceforge.net</a>
    </td>
  </tr>
</table>

<script type="text/javascript">
  <!--
  // Private objects are initially displayed (because if
  // javascript is turned off then we want them to be
  // visible); but by default, we want to hide them.  So hide
  // them unless we have a cookie that says to show them.
  checkCookie();
  // -->
</script>
</body>
</html>
